package com.spring.shops.dao;

import com.spring.shops.model.entity.TzTranscityFree;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface TzTranscityFreeMapper {
    int deleteByPrimaryKey(Long transcityFreeId);

    int insert(TzTranscityFree record);

    int insertSelective(TzTranscityFree record);

    TzTranscityFree selectByPrimaryKey(Long transcityFreeId);

    int updateByPrimaryKeySelective(TzTranscityFree record);

    int updateByPrimaryKey(TzTranscityFree record);

    /**
     * 根据免运费项id查询免运免费城市id
     * @param id
     * @return
     */
    @Select("select free_city_id from yami_shops.tz_transcity_free where transfee_free_id=#{id}")
    List<Long> getCityIdByFreeId(Long id);
}